GrapeCity.CalcEngine.Functions Namespace > CalcOffsetFunction Class > Evaluate Method : Evaluate(Object[]) Method |
The args contains 3 - 5 items: reference, rows, cols, [height], [width].
Reference is the reference from which you want to base the offset.
Rows is the number of rows, up or down, that you want the upper-left cell to refer to.
Cols is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to.
[Height] is the height, in number of rows, that you want the returned reference to be. Height must be a positive number.
[Width] is the width, in number of columns, that you want the returned reference to be. Width must be a positive number.
'Usage Dim instance As CalcOffsetFunction Dim args() As Object Dim value As Object value = instance.Evaluate(args)
The args contains 3 - 5 items: reference, rows, cols, [height], [width].
Reference is the reference from which you want to base the offset.
Rows is the number of rows, up or down, that you want the upper-left cell to refer to.
Cols is the number of columns, to the left or right, that you want the upper-left cell of the result to refer to.
[Height] is the height, in number of rows, that you want the returned reference to be. Height must be a positive number.
[Width] is the width, in number of columns, that you want the returned reference to be. Width must be a positive number.
Target Platforms: Windows Server 2012, Windows RT